Design and Analysis of DWH and BI in Education Domain

Data warehouse acting as a decision support systems, Data warehouses standardize the data across the organization so that there will be one view of information. Data warehouses can provide the information required by the decision makers. Developing a data warehouse for educational institute is the less focused area as educational institutes are non-profit and service oriented organizations. In present day scenario where education has been privatized and cut throat competition is prevailing, institutes needs to be more organized and need to take better decisions. Educational institute’s enrollments are increasing as a result of increase in the number of branches and intake. Today, any reputed Institute’s enrollments count in to thousands. The management challenges include meeting diverse student needs, increased complexity in academic processes. The complexity of these challenges requires continual improvements in operational strategies based on accurate, timely and consistent information. The cost of building a data warehouse is expensive for any educational institution as it requires data warehouse tools for building data warehouse and extracting data using data mining tools from data warehouse. The present study provides an option to build data warehouse and extract useful information using data warehousing and data mining open source tools.